Events

MySQL Event Scheduler was added in MySQL 5.1.6. MySQL Events are tasks that run according to a schedule. Therefore, we sometimes refer to them as scheduled events. When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Conceptually, this is similar to the idea of the Windows Task Scheduler.

Just simply click to open an object pane for Event. By using the object pane toolbar below, you can create new, edit and delete the selected event.

Create Event

To create a new event

To create a new event with the same properties as one of the existing event has (using drag and drop method)

Apply to: current database {same connection}
Apply to: different database {same connection}
  different database {different connection} (Data Transfer tool will be activated)
  • Select the event(s) for copying in the object pane.
  • Drag and drop the chosen event(s) to the target database.
  • Select one of the following options:

    • Copy
    • Cancel

To create a new event with the same properties as one of the existing event has

To create a new event with modification as one of the existing event

Edit Event

To edit the existing event (manage its definition etc)

To change the name of the event

Delete Event

To delete an event

Achieve Event Information

To achieve an event information